SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 35
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:If you are looking for a home that has a country feel, with a scenic country road access, yet offers Windsor VT, Claremont and the Upper Valley of NH, all within a 25 minute drive or less, this location will speak to you. This is a custom built home, that has hillside views (can be improved with some clearing), a brook at the north end of the property, a detached 2 car garage (2016), standby generator, privacy and gardens. Inside you have large spaces, vaulted ceilings, wood beams, a kitchen with a view and granite counters. The stone fireplace goes two stories high. In some houses that would be the focal point, this home offers several. The sunroom, it is sunny and bright, take in the view and stay warm with the gas fireplace. Step out onto the deck and take in the fresh air. The primary suite is large, has direct access to the deck and a bath that is just a dream. There is space for a in-home gym and office. The second floor has an open loft, two large bedrooms and full bath. Radiant heat on the main floor keeps you warm all winter and the newer metal roof gives you peace of mind. Other features: hardwood floors, paved driveway, pellet stove, water filtration, dumbwaiter and more! Delayed showings, showings start at the open house on Saturday 09/07 11am-1pm
Description:Welcome to your new home in Hanover! This stunning new construction boasts a spacious open floor plan, perfect for entertaining guests or enjoying quiet nights at home. With first floor laundry hookups and maintenance-free living, this home has all the modern conveniences you could ask for. Located just minutes away from Dartmouth College, Dartmouth Hospital, and multiple ski resorts, this property offers convenience and accessibility like no other. Whether you work on campus or want to explore all that Hanover has to offer, this location is unbeatable. Don't miss out on the opportunity to make this house your own - it's ready for a November move-in! Schedule a showing today and start envisioning yourself in your dream home in Hanover. Property will be complete and ready for move-in 11/30. Seller is a licensed New Hampshire real estate broker
Description:Discover your dream home in this serene 3 bedroom, 3 bathroom property set on 5 picturesque acres. A tree-lined lot provides privacy, giving you tranquility while the nearby neighbors offer a sense of community. Step inside to find beautiful hardwood floors that extend through much of the home. The spacious kitchen features stone counters, cherry cabinets, and stainless steel appliances. It connects seamlessly to the dining area, both of which are warmed by a cozy pellet stove, ideal for those chilly evenings and for reducing heating expenses! The main floor boasts a generous primary bedroom with ample closet space and a pretty 3/4 bath featuring dual sinks. Two additional bedrooms and versatile bonus rooms provide flexible living options, whether you need a home office, playroom, or guest space. Enjoy the convenient mudroom with lots of storage options, before heading out to the detached 2-car garage. Two additional sheds offer plenty of space for all your outdoor gear. Located in the sought-after Dresden School District, this home is a rare find--don't miss the opportunity to enjoy peaceful country living with modern comforts.
Description:Enjoy ultimate privacy and tranquility in this three bedroom, two and a half bath residence set on 3.8 acres in one of Lebanon's most desirable neighborhoods. Living room with gas fireplace for those cozy wintry evenings. Formal dining room plus kitchen with cherry cabinets and breakfast area with bay window to enjoy your natural surrounds. Primary en suite bedroom convenience on main level. Generously sized two bedrooms plus office on the second level. Plenty of storage and room for hobbies in the oversized garage and full basement. Large deck for your outside activities. Gardeners will certainly appreciate the greenhouse and organically cultivated raised beds plus relish in the generous harvests from the raspberry and blueberry patch. Easy drive to shopping, DHMC and area activities. Come take a look.
Description:Fantastic Mascoma Lake property with 93' of water frontage and breathtaking views of the surrounding mountains. The open layout connects a spacious kitchen, dining area, and family room with an adjacent screened-in seasonal porch to take in your dock, boat, and the expanse of the lake beyond. The interiors have recently been substantially renovated and upgraded, with a floor plan flow that accentuates the water view. There are three bedrooms upstairs, one of which is a primary suite overlooking the lake, while an office on the first floor could easily be converted into an additional bedroom. Stay warm in the winter with the pellet stove and radiant heat throughout. With so much fun on the lake leaving will be challenging, but when you do I-89 is nearby, making the rest of the Upper Valley readily accessible.